﻿--use PolePosition
GO


IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'up_VendorInspVisitXMissionStructurePole_SelectIdList')
	DROP PROCEDURE up_VendorInspVisitXMissionStructurePole_SelectIdList

GO

CREATE PROCEDURE up_VendorInspVisitXMissionStructurePole_SelectIdList
	 @Vendor_ProjectFK int 
	,@SearchByType varchar(50) = null
	,@SearchByText varchar(50) = null
	
AS

DECLARE @IdList varchar(MAX)
SET @IdList = ''


SELECT 
	 @IdList = @IdList + CONVERT(varchar, [Vendor_InspVisit_XMissionStructure_PoleId]) + ','
FROM v_tb_Vendor_InspVisit_XmissionStructures_Poles Pole
WHERE
	Pole.Vendor_ProjectFK = @Vendor_ProjectFK

SELECT @IdList


GO